Prime Ecosystem Core

The prime* tables mirror the external Prime Ecosystem job-management system, with primeJobs as the hub: contacts, users, statuses, appointments, work orders, allocations, estimates, and attachments all hang off a job. Data lands here via the spPrimeUpsert* sync procs.

Note Generated from relationships inference (procs/views + naming conventions). Relationships labelled inferred are low-confidence, naming-convention-only. Only key columns are shown per entity.